USE [Construarte]
GO

/****** Object: Table [dbo].[TipoConstrucao] Script Date: 31/08/2013 14:24:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TipoConstrucao] (
    [TipoConstrucaoId]   INT           IDENTITY (1, 1) NOT NULL,
    [DescTipoConstrucao] NVARCHAR (80) NOT NULL,
    PRIMARY KEY CLUSTERED ([TipoConstrucaoId] ASC)
);

SET IDENTITY_INSERT [dbo].[TipoConstrucao] ON
INSERT INTO [dbo].[TipoConstrucao] ([TipoConstrucaoId], [DescTipoConstrucao]) VALUES (1, N'Casa Madeira')
INSERT INTO [dbo].[TipoConstrucao] ([TipoConstrucaoId], [DescTipoConstrucao]) VALUES (2, N'Casa Alvenaria')
INSERT INTO [dbo].[TipoConstrucao] ([TipoConstrucaoId], [DescTipoConstrucao]) VALUES (3, N'Edificio Simples')
INSERT INTO [dbo].[TipoConstrucao] ([TipoConstrucaoId], [DescTipoConstrucao]) VALUES (4, N'Edificio Medio')
INSERT INTO [dbo].[TipoConstrucao] ([TipoConstrucaoId], [DescTipoConstrucao]) VALUES (5, N'Edificio Grande')
SET IDENTITY_INSERT [dbo].[TipoConstrucao] OFF



